employees and hire dates=Select Employees.[Employee ID],Employees.[Last Name],Employees.[First Name],Employees.[Birth Date],Employees.[Hire Date],Employees.[City] From Employees Where (Employees.[Hire Date] > #4/1/87#)
categories and products=Select Categories.[Category Name],Categories.[Description],Products.[Product Name],Products.[Quantity Per Unit],Products.[Unit Price],Products.[Units In Stock] From Categories,Products Where (Products.[Product Name] <> 'Carnarvon Tigers') And Categories.[Category ID]=Products.[Category ID]
products and suppliers=Select Products.[Product Name],Products.[Unit Price],Suppliers.[Company Name],Suppliers.[Contact Name],Suppliers.[City] From Products,Suppliers Where Products.[Supplier ID]=Suppliers.[Supplier ID]
categories suppliers products=Select Categories.[Category Name],Categories.[Description],Products.[Product Name],Products.[Quantity Per Unit],Suppliers.[Company Name],Suppliers.[Contact Name],Suppliers.[Phone] From Categories,Products,Suppliers, Categories INNER JOIN Products ON Categories.[Category ID]=Products.[Category ID],Products INNER JOIN Suppliers ON Products.[Supplier ID]=Suppliers.[Supplier ID]
new customers=Select Customers.[Company Name],Customers.[Address],Customers.[City],Customers.[Phone],Customers.[Customer ID] From Customers Where (Customers.[City] <> 'London' And CUSTOMERS.[CITY] <> "austin")
[PUBLIC]
Products you all=Select Products.[Supplier ID],Products.[Product Name],Products.[Quantity Per Unit],Products.[English Name],Products.[Unit Price] From Products
Simple shippers=Select Shippers.[Company Name],Shippers.[Shipper ID] From Shippers
